MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Templates / Business / Expenses System / Expense Line Items (.txt) < prev

Wrap

FileMaker Pro Database | 1996-01-25 | 111KB | 714 lines

5SC+8PzEy83NJbXp70AqGUhy5n6a XBamEMmp3puYQaIgc+/czYaRm4JWk8BWSxDNvqvIkcw1k3qA4IKnDo0F62gnFAfjAqey8KQ4JJdA UJGADJ/8MdIv9WKfUm7oxatgZOi9PyjFVPXzrB2SAaZiwdst01JRye0tJfZ65rLKcljs4XnXPbK8 WalsXWk4z93Mw8fGf9ysbnDK7KrKhuE9kHGM1+cMxVsXgEFZCKXgBznIyltVQWzk6yZCs2qE3I3d 2GCHCl8TOiAkpMtwhyIWVk6fzkxiJ3i5TwospeUPHrlD9EhcmcnUL9JuWcFhf2W5RLKbxgJido8n WB55T4RoKCm+Qo9PRbXJyJkForiYrhKjdbwFysPnuQm50ilusWBWpefOqJYPRjR38LAXgmBm80ou fzhe3rmSLVdr8J/CmlX1SVivhhz+zIgGCaIYlaJxQx9modrsd/r0Aok4BjJC+A6YB9GMJjge4ItZ HBAM2016AUG95 Pro 3.0 VDEFA HBAM3016AUG95 HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 Franz App AMOUNT 1 AMOUNT 2 AMOUNT 3 AMOUNT 4 AMOUNT 5 AMOUNT 6 AMOUNT 7 CREATED BY DATE CREATED DATE MODIFIED EMPLOYEE ID EXPENSE REPORT ID EXPENSE TYPE e RECORD ID SUMMARY TOTAL WEEK TOTAL AMOUNT 1 TOTAL AMOUNT 2 TOTAL AMOUNT 3 TOTAL AMOUNT 4 TOTAL AMOUNT 5 TOTAL AMOUNT 6 TOTAL AMOUNT 7 TOTAL WEEK Expense Report IDB Date CreatedB Date ModifiedB Amount 1B Amount 2B Amount 3B Amount 4B Amount 5B Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/27/95 Description This file contains all the line items on the expense form. By keeping the expense items in a separate file, you have more flexibility than you would if you used a repeating field. How to use this solution Each expense havs an ID number. This number groups all the line items ion the expense form. How to customize this solution Create your own custom reports to see exactly how much is spent in each category. A Form View A List View Expenses by Type Information Report Menu Expenses by Employee A Form ViewB Yesfter Noarter Amount 6B Amount 7B Expense TypeB Total Amount 1B Total Amount 2B Total Amount 3B Total Amount 4B Total Amount 5B Total Amount 6B Total Amount 7B Total WeekB Created ByB InfoB fA Record IDB Employee IDB Summary Total WeekB A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close !Enter data for Expense Line Items Expense Report ID Expense Expense Line Items Record ID Expenses File... Week Ending Total Employee Employees File... Expenses by TypeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Weekf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo Infop6Click to see more information for an Expense Line Item r Report ID Employee Expense Type Total Week InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Report ID Employee Amount Expenses by Type Expense Type Expenses by Type Page ## Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO.Information about the Expense Reports solutionP Info for this Solution Your Own ReportB Your Own ReportC Expenses by EmployeeD Expenses by TypeE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Expenses by EmployeeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF s by Type Sort by Last Name Sort by Date of End of Week Open Script Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Report ID Expense Type Amount Expenses by Employee Employee Expenses by Employee Page ## Sort by Expense Type Expenses by Employee Helvetica Geneva Times Times New Roman Arial MS Sans Serif C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) Sort by Expense Report ID Sort by Date of End of Week Sort by Last Name Sort by Expense Type Expenses by Type Expenses by Employee Open Script Sort by Expense Report ID Expenses by Type Sort by Last Name Sort by Date of End of Week Open Script wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw :RPTH FPTHA:HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 7RPTH FPTHA7HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Names.fp3 NAMEA Employee Names.fp3 RPTHA Employee Names.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 2RPTH FPTHA2HARDDISK:CONSULT:ClarisII:v4:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 WSPCA C:\CONSULT\ClarisII\v4\ (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 AD@D@ AD@D@ 44444 CCCCC 44444 CCCCC $42" @@BA@ bRBBP0 UUUUU JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! (*)(%,3& )%+@6) ",30,)% UUUUUU wwwwww #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10//O 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0% &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGS CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7[ !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww FMRLA FMRLA Employee ExpensesB Employee Names (LIST VDEFA( Expense Type ListB Project List VDEFA(